﻿CREATE TABLE [dbo].[Request]
(
	[Id] INT NOT NULL PRIMARY KEY, 
    [RequestUserId] INT NULL, 
    [RequestShiftTimePlaceId] INT NULL, 
    [OfferUserId] INT NULL, 
    [OfferShiftTimePlaceId] INT NULL, 
    [Accepted] NCHAR(10) NULL
	CONSTRAINT FK_Request_RequestUserId FOREIGN KEY ([RequestUserId]) REFERENCES [ScribeShiftTimeLocation](Id),
	CONSTRAINT FK_Request_RequestShiftTimeId FOREIGN KEY ([RequestShiftTimePlaceId]) REFERENCES Scribe(Id),
	CONSTRAINT FK_Request_OfferUserId FOREIGN KEY ([OfferUserId]) REFERENCES [ScribeShiftTimeLocation](Id),
	CONSTRAINT FK_Request_OfferShiftTimePlaceId FOREIGN KEY ([OfferShiftTimePlaceId]) REFERENCES Scribe(Id),

)
